/* indent size: 2 */

module.exports = app => {
    const DataTypes = app.Sequelize;

    const Model = app.model.define('characters3', {
        id: {
            type: DataTypes.INTEGER(10),
            allowNull: false,
            primaryKey: true,
            autoIncrement: true
        },
        name: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        age: {
            type: DataTypes.INTEGER(11),
            allowNull: true
        },
        sex: {
            type: DataTypes.INTEGER(4),
            allowNull: true
        },
        total_score: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        total_time: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        part1_score: {
            type: DataTypes.STRING(200),
            allowNull: true
        },
        part1_time: {
            type: DataTypes.STRING(200),
            allowNull: true
        },
        part1_wrong_list: {
            type: DataTypes.STRING(500),
            allowNull: true
        },
        part1_click_count_list: {
            type: DataTypes.STRING(2000),
            allowNull: true
        },
        part2_score: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        part2_time: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        part2_wrong_list: {
            type: DataTypes.STRING(500),
            allowNull: true
        },
        part2_click_count_list: {
            type: DataTypes.STRING(2000),
            allowNull: true
        },
        part3_score: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        part3_time: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        part3_wrong_list: {
            type: DataTypes.STRING(500),
            allowNull: true
        },
        part3_click_count_list: {
            type: DataTypes.STRING(2000),
            allowNull: true
        },
        create_time: {
            type: DataTypes.DATE,
            allowNull: true,
            defaultValue: DataTypes.literal('CURRENT_TIMESTAMP')
        },
        update_time: {
            type: DataTypes.DATE,
            allowNull: true,
            defaultValue: DataTypes.literal('CURRENT_TIMESTAMP')
        }
    }, {
        tableName: 'characters3'
    });

    Model.associate = function () {

    }

    return Model;
};
